DB_NAME = "example.db"

QUEUE_TABLE = "TAB_QUEUE"
VISITED_TABLE = "TAB_VISITED"

QUEUE_URL_COL = "url"
QUEUE_DESC_COL = "desc"

VISITED_URL_COL = "url"
VISITED_DESC_COL = "desc"
VISITED_KEYWORD_COL = "keywords"
VISITED_INDEX_COL = "index_main"

QUEUE_CREATE_STMT = "create table if not exists " + QUEUE_TABLE + "(" +\
                    QUEUE_URL_COL + " text, " + QUEUE_DESC_COL + " text)"
VISITED_CREATE_STMT = "create table if not exists " + VISITED_TABLE + "(" +\
                    VISITED_URL_COL + " text, " + VISITED_DESC_COL + " text, " +\
                    VISITED_KEYWORD_COL + " text, " + VISITED_INDEX_COL +\
                    " real)"

QUEUE_INSERT_TEMPLATE = "insert into " + QUEUE_TABLE + "(" + QUEUE_URL_COL +\
                        ", " + QUEUE_DESC_COL + ") values (?, ?)"
